require("inc.php");
session_start();
//MySQLに接続
if(!$conn = mysql_connect(_DB_SERVER,_DB_UID,_DB_PASS)){
die('MySQL接続失敗');
}
//データベースの選択
if(!$sts = mysql_select_db(_DB_NAME,$conn)){
die('テーブル選択失敗');
}
$artnum = $_GET['artnum'];
$sql="";
$sql.="select * from album where artnum = '$artnum' group by artnum ";
$mq = mysql_query($sql,$conn);
if($rec = mysql_fetch_array($mq)){
$ownerid = _hs($rec['id']);
$Rdata = _hs($rec['date']);
$title = _hs($rec['title']);
$category = _hs($rec['category']);
$temp = _hs($rec['temp']);
$com = _hs($rec['com']);
$com = str_replace("\n","
",$com);
$com = str_replace("&","&",$com);
$com = ereg_replace("(https?|ftp|news)(://[[:alnum:]\+\$\;\?\.%,!#~*/:@&=_-]+)","\\1\\2",$com);
$img1com = _hs($rec['img1com']);
$img2com = _hs($rec['img2com']);
$img3com = _hs($rec['img3com']);
$Odate = _hs($rec['Odate']);
$ex = _hs($rec['ex']);
$id = _hs($rec['id']);
}
$sqll="";
$sqll.="select * from profile where id = '$id' group by id";
$mqli = mysql_query($sqll,$conn);
if($rec2 = mysql_fetch_array($mqli)){
$name = $rec2['name'];
}
$u1 = "${ownerid}/"."${Rdata}/"."image1".".jpg";
$u2 = "${ownerid}/"."${Rdata}/"."image2".".jpg";
$u3 = "${ownerid}/"."${Rdata}/"."image3".".jpg";
$img1flg="";
$img2flg="";
$img3flg="";
if(file_exists("$u1")){
$img1flg=1;
$percent=0;
//画像サイズ自動変更処理
list($width, $height) = getimagesize("$u1");
if($width > $height){
if($width > 180){
$percent = 180 / $width;
}
}elseif($width < $height){
if($height > 135){
$percent = 135 / $height;
}
}else{
if($width > 180){
$percent = 180 / $width;
}
if($height > 135){
$percent = 135 / $height;
}
}
if($percent > 0){
$new_width1 = $width * $percent;
$new_height1 = $height * $percent;
}else{
$new_width1 = $width;
$new_height1 = $height;
}
}
if(file_exists("$u2")){
$img2flg=1;
$percent=0;
//画像サイズ自動変更処理
list($width, $height) = getimagesize("$u2");
if($width > $height){
if($width > 180){
$percent = 180 / $width;
}
}elseif($width < $height){
if($height > 135){
$percent = 135 / $height;
}
}else{
if($width > 180){
$percent = 180 / $width;
}
if($height > 135){
$percent = 135 / $height;
}
}
if($percent > 0){
$new_width2 = $width * $percent;
$new_height2 = $height * $percent;
}else{
$new_width2 = $width;
$new_height2 = $height;
}
}
if(file_exists("$u3")){
$img3flg=1;
$percent=0;
//画像サイズ自動変更処理
list($width, $height) = getimagesize("$u3");
if($width > $height){
if($width > 180){
$percent = 180 / $width;
}
}elseif($width < $height){
if($height > 135){
$percent = 135 / $height;
}
}else{
if($width > 180){
$percent = 180 / $width;
}
if($height > 135){
$percent = 135 / $height;
}
}
if($percent > 0){
$new_width3 = $width * $percent;
$new_height3 = $height * $percent;
}else{
$new_width3 = $width;
$new_height3 = $height;
}
}
$Gnum = 0;
$g_data=array();
$g_name=array();
$g_com=array();
$sql="";
$sql.="select * from comment where artnum = '$artnum' order by date ";
$mq = mysql_query($sql,$conn);
while($rec = mysql_fetch_array($mq)){
$g_data[$Gnum] = _hs($rec['date']);
$f_com = _hs($rec['com']);
$f_com = str_replace("\n","
",$f_com);
$g_com[$Gnum] = $f_com;
$g_id=_hs($rec['id']);
$sql="";
$sql.="select name from profile where id = '$g_id' ";
$mqa = mysql_query($sql,$conn);
if($rec2 = mysql_fetch_array($mqa)){
$g_name[$Gnum]=$rec2['name'];
if($g_name[$Gnum]==""){
$g_name[$Gnum]=$g_id;
}
}else{
$g_name[$Gnum]=$g_id;
}
$Gnum++;
}
?>
mb_language("Ja") ;
mb_internal_encoding("JIS") ;
header('content-type: text/html; charset =' ._CHARSET);
?>
マウスだけで簡単に作れる ブログワン
//更新履歴の表示処理
$rireki = _rireki();
echo "$rireki";
?>
記事が実際にアップされた日付の新しいものから順番に表示されます。
|
タイトル順に表示されます。
|
|